﻿using System;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;

namespace BRMC.IntelligentCommunity.Migrations
{
    public partial class add_other_base : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
        //    migrationBuilder.AlterColumn<DateTime>(
        //        name: "Timestamp",
        //        table: "App_user",
        //        maxLength: 50,
        //        nullable: true,
        //        oldClrType: typeof(string),
        //        oldMaxLength: 50,
        //        oldNullable: true);

        //    migrationBuilder.CreateTable(
        //        name: "Evaluate_index",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Pid = table.Column<int>(nullable: false),
        //            Name = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Evaluate_index", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "product_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Name = table.Column<string>(nullable: true),
        //            Largeclass = table.Column<int>(nullable: false, defaultValue: 0),
        //            Subclass = table.Column<int>(nullable: false, defaultValue: 1),
        //            Sort = table.Column<int>(nullable: false, defaultValue: 1),
        //            Price = table.Column<decimal>(type: "decimal(10,2)", nullable: false),
        //            Discount = table.Column<decimal>(type: "decimal(10,2)", nullable: false),
        //            Icon = table.Column<string>(nullable: true),
        //            Describe = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_product_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_banner",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Sort = table.Column<int>(nullable: false),
        //            Name = table.Column<string>(nullable: true),
        //            Url = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_banner", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_data_set",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Name = table.Column<string>(nullable: true),
        //            Value = table.Column<int>(nullable: false),
        //            Unit = table.Column<string>(nullable: true),
        //            Desc = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_data_set", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_house_chart",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Name = table.Column<string>(nullable: true),
        //            Files = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_house_chart", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_house_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Neighbourhood_id = table.Column<int>(nullable: false, defaultValue: 0),
        //            Ridgepole = table.Column<string>(nullable: true),
        //            Unit = table.Column<string>(nullable: true),
        //            Floor = table.Column<string>(nullable: true),
        //            Room_num = table.Column<string>(nullable: true),
        //            Chart = table.Column<int>(nullable: false, defaultValue: 0),
        //            All = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0),
        //            P_num = table.Column<int>(nullable: false, defaultValue: 1),
        //            Use_status = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_house_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_information",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Title = table.Column<string>(nullable: true),
        //            Content = table.Column<string>(nullable: true),
        //            Icon = table.Column<string>(nullable: true),
        //            Pict_path = table.Column<string>(nullable: true),
        //            Filename = table.Column<string>(nullable: true),
        //            Author = table.Column<string>(nullable: true),
        //            Date = table.Column<DateTime>(nullable: false),
        //            Reads = table.Column<int>(nullable: false, defaultValue: 0),
        //            Top = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_information", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_neighbourhood_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Name = table.Column<string>(nullable: true),
        //            Site = table.Column<string>(nullable: true),
        //            Ridgepole = table.Column<int>(nullable: false, defaultValue: 0),
        //            Family = table.Column<int>(nullable: false, defaultValue: 0),
        //            Longitude = table.Column<decimal>(type: "decimal(10,6)", nullable: false),
        //            Latitude = table.Column<decimal>(type: "decimal(10,6)", nullable: false),
        //            Span_class = table.Column<int>(nullable: false, defaultValue: 1),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0),
        //            Iscover = table.Column<int>(nullable: false, defaultValue: 1),
        //            Companyid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Xq_pin_yin = table.Column<string>(nullable: true),
        //            Xq_py = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_neighbourhood_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_notice",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Img_name = table.Column<string>(nullable: true),
        //            Img_url = table.Column<string>(nullable: true),
        //            File_name = table.Column<string>(nullable: true),
        //            File_url = table.Column<string>(nullable: true),
        //            Title = table.Column<string>(nullable: true),
        //            Content = table.Column<string>(nullable: true),
        //            Top = table.Column<int>(nullable: false, defaultValue: 0),
        //            Clicks = table.Column<int>(nullable: false, defaultValue: 0),
        //            Timestamp = table.Column<DateTime>(nullable: false),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_notice", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_site_dict",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Index = table.Column<int>(nullable: false, defaultValue: 0),
        //            Value = table.Column<int>(nullable: false, defaultValue: 0),
        //            Note = table.Column<string>(nullable: true),
        //            Relevant_val = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
        //            Keyword = table.Column<string>(nullable: true),
        //            Remark = table.Column<string>(nullable: true),
        //            Is_del = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_site_dict", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_site_dict_index",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Note = table.Column<string>(nullable: true),
        //            Is_del = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_site_dict_index", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Sys_verification_code",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Openid = table.Column<string>(nullable: true),
        //            Phone = table.Column<string>(nullable: true),
        //            Code = table.Column<int>(nullable: false),
        //            Creat_time = table.Column<int>(nullable: false),
        //            Expire_time = table.Column<int>(nullable: false),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Sys_verification_code", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_apply_reside_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Openid = table.Column<string>(nullable: true),
        //            Apply_type = table.Column<int>(nullable: false, defaultValue: 0),
        //            Type = table.Column<string>(nullable: true),
        //            Province = table.Column<string>(nullable: true),
        //            City = table.Column<string>(nullable: true),
        //            Region = table.Column<string>(nullable: true),
        //            Neighbourhood = table.Column<string>(nullable: true),
        //            DetailedAddress = table.Column<string>(nullable: true),
        //            Name = table.Column<string>(nullable: true),
        //            Gender = table.Column<string>(nullable: true),
        //            Birth = table.Column<string>(nullable: true),
        //            Nationality = table.Column<string>(nullable: true),
        //            Address = table.Column<string>(nullable: true),
        //            Idcardno = table.Column<string>(nullable: true),
        //            Authority = table.Column<string>(nullable: true),
        //            Valid_date = table.Column<string>(nullable: true),
        //            PurePhoneNumber = table.Column<string>(nullable: true),
        //            Phone = table.Column<string>(nullable: true),
        //            Apply_time = table.Column<DateTime>(nullable: false),
        //            Audit_time = table.Column<DateTime>(nullable: false),
        //            Auditor = table.Column<string>(nullable: true),
        //            Auditor_userid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Status = table.Column<int>(nullable: false, defaultValue: 0),
        //            Reason = table.Column<string>(nullable: true),
        //            P_num = table.Column<int>(nullable: false, defaultValue: 1),
        //            Use_status = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_apply_reside_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_base_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<long>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Name = table.Column<string>(nullable: true),
        //            Identification = table.Column<string>(nullable: true),
        //            Birthday = table.Column<string>(nullable: true),
        //            Email = table.Column<string>(nullable: true),
        //            Phone = table.Column<string>(nullable: true),
        //            Password = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_base_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_broadband_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Userid = table.Column<long>(nullable: false, defaultValue: 0L),
        //            Openid = table.Column<string>(nullable: true),
        //            Price_package_id = table.Column<int>(nullable: false, defaultValue: 0),
        //            Name = table.Column<string>(nullable: true),
        //            Accepted_date = table.Column<string>(nullable: true),
        //            Due_date = table.Column<string>(nullable: true),
        //            Duration = table.Column<int>(nullable: false, defaultValue: 0),
        //            Bandwidth = table.Column<int>(nullable: false, defaultValue: 0),
        //            Present = table.Column<string>(nullable: true),
        //            Charges = table.Column<decimal>(nullable: false),
        //            Remark = table.Column<string>(nullable: true),
        //            Type = table.Column<int>(nullable: false, defaultValue: 1),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0),
        //            Gm_money = table.Column<string>(nullable: true),
        //            Jdh_money = table.Column<string>(nullable: true),
        //            Lyq_money = table.Column<string>(nullable: true),
        //            Goods_income = table.Column<string>(nullable: true),
        //            Operator = table.Column<string>(nullable: true),
        //            Opdate = table.Column<DateTime>(nullable: false),
        //            Service_id = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isagent = table.Column<int>(nullable: false, defaultValue: 0),
        //            By_agent_userid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Detailadd = table.Column<string>(nullable: true),
        //            Userid_base = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_broadband_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_excel_import_tmp",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Name = table.Column<string>(nullable: true),
        //            Phone = table.Column<string>(nullable: true),
        //            Realname = table.Column<string>(nullable: true),
        //            Addrees = table.Column<string>(nullable: true),
        //            Bb_money = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
        //            Gm_money = table.Column<string>(nullable: true),
        //            Jdh_money = table.Column<string>(nullable: true),
        //            Lyq_money = table.Column<string>(nullable: true),
        //            Total = table.Column<string>(nullable: true),
        //            Pay_type = table.Column<string>(nullable: true),
        //            Biz_type = table.Column<string>(nullable: true),
        //            Duration = table.Column<string>(nullable: true),
        //            Bandwidth = table.Column<string>(nullable: true),
        //            Begin_date = table.Column<string>(nullable: true),
        //            End_date = table.Column<string>(nullable: true),
        //            Goods_income = table.Column<string>(nullable: true),
        //            Opname = table.Column<string>(nullable: true),
        //            Operator = table.Column<int>(nullable: false, defaultValue: 0),
        //            Userid = table.Column<long>(nullable: false, defaultValue: 0L),
        //            Remark = table.Column<string>(nullable: true),
        //            Excel_name = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_excel_import_tmp", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_house_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Userid = table.Column<long>(nullable: false, defaultValue: 0L),
        //            Houseid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Numbers = table.Column<int>(nullable: false, defaultValue: 1),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0),
        //            Applyid = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_house_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_idcard_pict_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Apply_id = table.Column<int>(nullable: false, defaultValue: 0),
        //            Openid = table.Column<string>(nullable: true),
        //            Idcard_a = table.Column<string>(nullable: true),
        //            Idcard_b = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_idcard_pict_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_pay_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Userid = table.Column<long>(nullable: false, defaultValue: 0L),
        //            Openid = table.Column<string>(nullable: true),
        //            Price_package_id = table.Column<int>(nullable: false, defaultValue: 1),
        //            Total = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
        //            Payment_method = table.Column<int>(nullable: false, defaultValue: 1),
        //            Type = table.Column<int>(nullable: false, defaultValue: 0),
        //            Out_trade_no = table.Column<string>(nullable: true),
        //            Description = table.Column<string>(nullable: true),
        //            Timestamp = table.Column<DateTime>(nullable: false),
        //            Remark = table.Column<string>(nullable: true),
        //            Detailadd = table.Column<string>(nullable: true),
        //            Isagent = table.Column<int>(nullable: false, defaultValue: 0),
        //            By_agent_userid = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_pay_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_sys_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Userid = table.Column<long>(nullable: false, defaultValue: 0L),
        //            Openid = table.Column<string>(nullable: true),
        //            Newmsgs = table.Column<int>(nullable: false, defaultValue: 0),
        //            Evaluate_broadband = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_sys_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "User_wechat_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Userid = table.Column<long>(nullable: false, defaultValue: 0L),
        //            Openid = table.Column<string>(nullable: true),
        //            PhoneNumber = table.Column<string>(nullable: true),
        //            PurePhoneNumber = table.Column<string>(nullable: true),
        //            CountryCode = table.Column<string>(nullable: true),
        //            Gender = table.Column<int>(nullable: false, defaultValue: 0),
        //            Region = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_User_wechat_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Vote",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Title = table.Column<string>(nullable: true),
        //            Describe = table.Column<string>(nullable: true),
        //            Votetype = table.Column<int>(nullable: false, defaultValue: 1),
        //            Maxoptionnum = table.Column<int>(nullable: false, defaultValue: 0),
        //            Voterange = table.Column<int>(nullable: false, defaultValue: 0),
        //            Itemnum = table.Column<int>(nullable: false, defaultValue: 0),
        //            Endtime = table.Column<int>(nullable: false, defaultValue: 0),
        //            Userid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Timestamp = table.Column<int>(nullable: false, defaultValue: 0),
        //            Allvotes = table.Column<int>(nullable: false, defaultValue: 0),
        //            Votecount = table.Column<int>(nullable: false, defaultValue: 0),
        //            Turnout = table.Column<float>(nullable: false),
        //            Mancount = table.Column<int>(nullable: false, defaultValue: 0),
        //            Womancount = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isshow = table.Column<int>(nullable: false, defaultValue: 1),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Vote", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Vote_items",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Voteid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Item = table.Column<string>(nullable: true),
        //            Votenum = table.Column<int>(nullable: false, defaultValue: 0),
        //            Percent = table.Column<float>(nullable: false),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Vote_items", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Vote_user_log",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Openid = table.Column<string>(nullable: true),
        //            Voteid = table.Column<int>(nullable: false),
        //            Isvote = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Vote_user_log", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Vote_users",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Voteid = table.Column<int>(nullable: false),
        //            Itemid = table.Column<int>(nullable: false),
        //            Openid = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Vote_users", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Work_evaluate_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Openid = table.Column<string>(nullable: true),
        //            Bb_score = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
        //            Bb_evaluate_number = table.Column<int>(nullable: false, defaultValue: 0),
        //            Bb_total_score = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Work_evaluate_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Work_wechat_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Userid = table.Column<long>(nullable: false, defaultValue: 0L),
        //            Openid = table.Column<string>(nullable: true),
        //            PhoneNumber = table.Column<string>(nullable: true),
        //            PurePhoneNumber = table.Column<string>(nullable: true),
        //            CountryCode = table.Column<string>(nullable: true),
        //            Gender = table.Column<int>(nullable: false, defaultValue: 0),
        //            Region = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0),
        //            Optime = table.Column<DateTime>(nullable: false)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Work_wechat_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_facility_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Classid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Title = table.Column<string>(nullable: true),
        //            Number = table.Column<string>(nullable: true),
        //            Longitude = table.Column<string>(nullable: true),
        //            Latitude = table.Column<string>(nullable: true),
        //            Location = table.Column<string>(nullable: true),
        //            Remark = table.Column<string>(nullable: true),
        //            Qrcode_url = table.Column<string>(nullable: true),
        //            Neig_id = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_facility_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_material_tool_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Name = table.Column<string>(nullable: true),
        //            Type = table.Column<int>(nullable: false, defaultValue: 0),
        //            Amount = table.Column<int>(nullable: false, defaultValue: 0),
        //            Classid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Optime = table.Column<DateTime>(nullable: false),
        //            Operater = table.Column<int>(nullable: false, defaultValue: 0),
        //            Opname = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_material_tool_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_material_tool_inout_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Itemid = table.Column<int>(nullable: false),
        //            Biztype = table.Column<int>(nullable: false, defaultValue: 1),
        //            Mtid = table.Column<int>(nullable: false),
        //            Inout = table.Column<int>(nullable: false, defaultValue: 0),
        //            Workerid = table.Column<int>(nullable: false),
        //            Getdate = table.Column<DateTime>(nullable: false),
        //            Remark_w = table.Column<string>(nullable: true),
        //            Keeper = table.Column<int>(nullable: false, defaultValue: 0),
        //            Optime = table.Column<DateTime>(nullable: false),
        //            Remark_k = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_material_tool_inout_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_mt_inout_details",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Mti_id = table.Column<int>(nullable: false),
        //            Mt_id = table.Column<int>(nullable: false),
        //            Remark = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_mt_inout_details", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_repairs_equipment_class",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Pid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Name = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isprivate = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_repairs_equipment_class", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_repairs_work_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Repairsid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Customer_service_id = table.Column<int>(nullable: false, defaultValue: 0),
        //            Customer_service_openid = table.Column<string>(nullable: true),
        //            Customer_service_name = table.Column<string>(nullable: true),
        //            Accept_time = table.Column<DateTime>(nullable: false),
        //            Work_id = table.Column<int>(nullable: false, defaultValue: 0),
        //            Work_openid = table.Column<string>(nullable: true),
        //            Work_name = table.Column<string>(nullable: true),
        //            Finish_time = table.Column<DateTime>(nullable: false),
        //            Longitude = table.Column<string>(nullable: true),
        //            Latitude = table.Column<string>(nullable: true),
        //            Arrive_time = table.Column<DateTime>(nullable: false),
        //            Customer_service_remark = table.Column<string>(nullable: true),
        //            Work_remark = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_repairs_work_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_user_evaluate_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Openid = table.Column<string>(nullable: true),
        //            Biztype = table.Column<int>(nullable: false, defaultValue: 1),
        //            Bizid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Work_order_no = table.Column<string>(nullable: true),
        //            Customer_service_openid = table.Column<string>(nullable: true),
        //            Customer_service_sorce = table.Column<int>(nullable: false, defaultValue: 0),
        //            Accept_time = table.Column<DateTime>(nullable: false),
        //            Repairs_openid = table.Column<string>(nullable: true),
        //            Repairs_sorce = table.Column<int>(nullable: false, defaultValue: 0),
        //            Finish_time = table.Column<DateTime>(nullable: false),
        //            Timestamp = table.Column<DateTime>(nullable: false),
        //            Remark = table.Column<string>(nullable: true),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_user_evaluate_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_user_evaluate_pict",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Evaluate_id = table.Column<int>(nullable: false),
        //            Pictname = table.Column<int>(nullable: false),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_user_evaluate_pict", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_user_repairs_comments_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Repairsid = table.Column<int>(nullable: false),
        //            Userid = table.Column<long>(nullable: false),
        //            Openid = table.Column<string>(nullable: true),
        //            Content = table.Column<string>(nullable: true),
        //            Comments_date = table.Column<DateTime>(nullable: false),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_user_repairs_comments_info", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_user_repairs_comments_pict",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Re_comments_id = table.Column<int>(nullable: false),
        //            Pict_url = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_user_repairs_comments_pict", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_user_repairs_list",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Userid = table.Column<long>(nullable: false),
        //            Openid = table.Column<string>(nullable: true),
        //            Work_order_no = table.Column<string>(nullable: true),
        //            Classid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Fa_type = table.Column<int>(nullable: false, defaultValue: 0),
        //            Re_date = table.Column<DateTime>(nullable: false),
        //            Appt_date = table.Column<string>(nullable: true),
        //            Appt_b_time = table.Column<string>(nullable: true),
        //            Appt_e_time = table.Column<string>(nullable: true),
        //            Status = table.Column<int>(nullable: false, defaultValue: 1),
        //            Op_date = table.Column<DateTime>(nullable: false),
        //            Remark = table.Column<string>(nullable: true),
        //            Date_change_w = table.Column<int>(nullable: false, defaultValue: 0),
        //            Date_change_u = table.Column<int>(nullable: false, defaultValue: 0),
        //            Eval_status = table.Column<int>(nullable: false, defaultValue: 0),
        //            Comments_times = table.Column<int>(nullable: false, defaultValue: 0),
        //            Praise_times_u = table.Column<int>(nullable: false, defaultValue: 0),
        //            Praise_times_w = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isshow = table.Column<int>(nullable: false, defaultValue: 0),
        //            Neig_id = table.Column<int>(nullable: false, defaultValue: 0),
        //            Compid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Isaudit = table.Column<int>(nullable: false, defaultValue: 0),
        //            Address = table.Column<string>(nullable: true),
        //            Lat = table.Column<string>(nullable: true),
        //            Lng = table.Column<string>(nullable: true),
        //            UserName = table.Column<string>(nullable: true),
        //            UserPhone = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_user_repairs_list", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_user_repairs_log",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Repairsid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Optime = table.Column<DateTime>(nullable: false),
        //            Status = table.Column<int>(nullable: false, defaultValue: 1),
        //            Servicerid = table.Column<int>(nullable: false, defaultValue: 0),
        //            Sname = table.Column<string>(nullable: true),
        //            User_type = table.Column<int>(nullable: false, defaultValue: 1),
        //            Remark = table.Column<string>(nullable: true)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_user_repairs_log", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_user_repairs_pict",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Repairsid = table.Column<int>(nullable: false),
        //            Ppict_url = table.Column<string>(nullable: true),
        //            Optime = table.Column<DateTime>(nullable: false)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_user_repairs_pict", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_user_repairs_praise",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Repairsid = table.Column<int>(nullable: false),
        //            Userid = table.Column<long>(nullable: false),
        //            Openid = table.Column<string>(nullable: true),
        //            Ptype = table.Column<int>(nullable: false, defaultValue: 0),
        //            Ispraise = table.Column<int>(nullable: false, defaultValue: 1),
        //            Optime = table.Column<DateTime>(nullable: false),
        //            Isdel = table.Column<int>(nullable: false, defaultValue: 0)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_user_repairs_praise", x => x.Id);
        //        });

        //    migrationBuilder.CreateTable(
        //        name: "Wy_work_evaluate_info",
        //        columns: table => new
        //        {
        //            Id = table.Column<int>(nullable: false)
        //                .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
        //            Openid = table.Column<string>(nullable: true),
        //            Score = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
        //            Eval_num = table.Column<int>(nullable: false, defaultValue: 0),
        //            Totel_score = table.Column<decimal>(type: "decimal(18,2)", nullable: false)
        //        },
        //        constraints: table =>
        //        {
        //            table.PrimaryKey("PK_Wy_work_evaluate_info", x => x.Id);
        //        });
        //}

        //protected override void Down(MigrationBuilder migrationBuilder)
        //{
        //    migrationBuilder.DropTable(
        //        name: "Evaluate_index");

        //    migrationBuilder.DropTable(
        //        name: "product_info");

        //    migrationBuilder.DropTable(
        //        name: "Sys_banner");

        //    migrationBuilder.DropTable(
        //        name: "Sys_data_set");

        //    migrationBuilder.DropTable(
        //        name: "Sys_house_chart");

        //    migrationBuilder.DropTable(
        //        name: "Sys_house_info");

        //    migrationBuilder.DropTable(
        //        name: "Sys_information");

        //    migrationBuilder.DropTable(
        //        name: "Sys_neighbourhood_info");

        //    migrationBuilder.DropTable(
        //        name: "Sys_notice");

        //    migrationBuilder.DropTable(
        //        name: "Sys_site_dict");

        //    migrationBuilder.DropTable(
        //        name: "Sys_site_dict_index");

        //    migrationBuilder.DropTable(
        //        name: "Sys_verification_code");

        //    migrationBuilder.DropTable(
        //        name: "User_apply_reside_info");

        //    migrationBuilder.DropTable(
        //        name: "User_base_info");

        //    migrationBuilder.DropTable(
        //        name: "User_broadband_info");

        //    migrationBuilder.DropTable(
        //        name: "User_excel_import_tmp");

        //    migrationBuilder.DropTable(
        //        name: "User_house_info");

        //    migrationBuilder.DropTable(
        //        name: "User_idcard_pict_info");

        //    migrationBuilder.DropTable(
        //        name: "User_pay_info");

        //    migrationBuilder.DropTable(
        //        name: "User_sys_info");

        //    migrationBuilder.DropTable(
        //        name: "User_wechat_info");

        //    migrationBuilder.DropTable(
        //        name: "Vote");

        //    migrationBuilder.DropTable(
        //        name: "Vote_items");

        //    migrationBuilder.DropTable(
        //        name: "Vote_user_log");

        //    migrationBuilder.DropTable(
        //        name: "Vote_users");

        //    migrationBuilder.DropTable(
        //        name: "Work_evaluate_info");

        //    migrationBuilder.DropTable(
        //        name: "Work_wechat_info");

        //    migrationBuilder.DropTable(
        //        name: "Wy_facility_info");

        //    migrationBuilder.DropTable(
        //        name: "Wy_material_tool_info");

        //    migrationBuilder.DropTable(
        //        name: "Wy_material_tool_inout_info");

        //    migrationBuilder.DropTable(
        //        name: "Wy_mt_inout_details");

        //    migrationBuilder.DropTable(
        //        name: "Wy_repairs_equipment_class");

        //    migrationBuilder.DropTable(
        //        name: "Wy_repairs_work_info");

        //    migrationBuilder.DropTable(
        //        name: "Wy_user_evaluate_info");

        //    migrationBuilder.DropTable(
        //        name: "Wy_user_evaluate_pict");

        //    migrationBuilder.DropTable(
        //        name: "Wy_user_repairs_comments_info");

        //    migrationBuilder.DropTable(
        //        name: "Wy_user_repairs_comments_pict");

        //    migrationBuilder.DropTable(
        //        name: "Wy_user_repairs_list");

        //    migrationBuilder.DropTable(
        //        name: "Wy_user_repairs_log");

        //    migrationBuilder.DropTable(
        //        name: "Wy_user_repairs_pict");

        //    migrationBuilder.DropTable(
        //        name: "Wy_user_repairs_praise");

        //    migrationBuilder.DropTable(
        //        name: "Wy_work_evaluate_info");

        //    migrationBuilder.AlterColumn<string>(
        //        name: "Timestamp",
        //        table: "App_user",
        //        maxLength: 50,
        //        nullable: true,
        //        oldClrType: typeof(DateTime),
        //        oldMaxLength: 50,
        //        oldNullable: true);
        }
    }
}
